Create Crimes Per Day
Step 1: Choose a line and clustered Column chart
a. Shared Axis = Day of Week and Time by Hour, Column Values = Average Crimes per weekday, Line Values = Crimes average per Day YOY%
b. Select formatting, in general X position = 10, Y position = 405, Width = 508, Height = 314
c. X axis, color = black, text size = 10, font = Constantia, title off, turn off the legend
d. Y axis, start = .1, color = black, text size = 10, font = Constantia, title off, show secondary on, color = black, text size = 10, font = Constantia
e. Data Colors, Crime per Day YOY = custom (FCB714), Default color is formatted by field value, based on color measure for columns
f. Data labels, color = black, background turned off, text size 10, font = Constantia, customize series on, average per weekday should be off
g. Shapes, shade area should be on
h. Title, Crimes Per Day, color black, background color = light gray, alignment = center, text size = 12, font = Constantia
i. Border = dark gray
j. Change Crimes average per Day YOY% to a percentage